Solution Migration

The solution migration is a command line tool that can be used to migrate from Partner Management to Solution Hub.

info

• For a successful migration the partner database has to be prepared.
• This preparation is done with the orchestra_partner_migration tool that is found in the orchestra installation.

---

The basic steps for a successful migration are:

Step 1: Execute orchestra_partner_migration
Step 2: Execute solution_migration

---

How to use

To use the tool, follow these steps:

1. Open your Command Prompt or Terminal

2. Navigate to the directory where the solution_migration is located

3. Enter the command solution_migration followed by the required parameters and options

---

Migration: Partner Management to Solution Hub

Migrate from Partner Management to Solution Hub.

Parameter	Type	Description
-db_type, --database_type	Required	This parameter is for the Solution Hub database type.
-db_url, --database_url	Required	This parameter is for the Solution Hub connection URL.
-db_u, --database_username	Required	This parameter is for the Solution Hub database username.
-db_p, --database_password	Required	This parameter is for the Solution Hub database password.
-pn_db_type, --pn_database_type	Required	This parameter is for the Partner Management database type.
-pn_db_url, --pn_database_url	Required	This parameter is for the Partner Management connection URL.
-pn_db_u, --pn_database_username	Required	This parameter is for the Partner Management database username.
-pn_db_p, --pn_database_password	Required	This parameter is for the Partner Management database password.

Example

-db_type MSSQL -db_url jdbc:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;DatabaseName=SOLUTIONHUB;trustServerCertificate=true; -db_u user -db_p password -pn_db_type MSSQL -pn_db_url jdbc:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;DatabaseName=PARTNER;trustServerCertificate=true; -pn_db_u user -pn_db_p password

---

Parameter Option Example

The database type:

• MSSQL
• MYSQL
• ORACLE
• POSTGRESQL
• MARIADB
• Derby

The database connection URL:

• MSSQL
  jdbc:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;DatabaseName=ORC;trustServerCertificate=true;

• MYSQL
  jdbc:mysql://localhost:3306/ORC?verifyServerCertificate=false&useSSL=true&serverTimezone=UTC

• ORACLE
  jdbc:oracle:thin:@localhost:1521:ORC

• POSTGRESQL
  jdbc:postgresql://localhost:5432/ORC

• MARIADB
  jdbc:mariadb://localhost:3306/ORC

• Derby
  jdbc:derby:/path/to/database